DECLARE @userid int
DECLARE @customerid int

INSERT INTO [User] (Username, Password) VALUES ('username', 'password')

SET @userid = SCOPE_IDENTITY()

INSERT INTO [Customer] (UserID, FirstName, LastName, PhoneNumber, EmailAddress, ParentCustomerID)
VALUES (@userid, 'Test', 'Customer', '719-555-1234', 'test.customer@usoc.org', null)


-- for child customers

INSERT INTO [User] (Username, Password) VALUES ('username2', 'password')

SET @userid = SCOPE_IDENTITY()

INSERT INTO [Customer] (UserID, FirstName, LastName, PhoneNumber, EmailAddress, ParentCustomerID)
VALUES (@userid, 'Test', 'Customer2', '719-555-1234', 'test.customer@usoc.org', null)

set @customerid = SCOPE_IDENTITY()

-- child customers
INSERT INTO [User] (Username, Password) VALUES ('username2', 'password')

SET @userid = SCOPE_IDENTITY()

INSERT INTO [Customer] (UserID, FirstName, LastName, PhoneNumber, EmailAddress, ParentCustomerID)
VALUES (@userid, 'Test', 'Customer3', '719-555-1234', 'test.customer@usoc.org', @customerid)

INSERT INTO [User] (Username, Password) VALUES ('username2', 'password')

SET @userid = SCOPE_IDENTITY()

INSERT INTO [Customer] (UserID, FirstName, LastName, PhoneNumber, EmailAddress, ParentCustomerID)
VALUES (@userid, 'Test', 'Customer4', '719-555-1234', 'test.customer@usoc.org', @customerid)
